home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
vprobing.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
1KB
|
27 lines
/*
This view gathers the data for the probing daily activity report, using the context method. Appropriate summing is done by the report.
*/
create or replace view vprobing as
select probehist.pdate,
probehist.conversion_num,
probehist.cbintent pull,
vcuraccparts.PROBE_CONTEXT,
vcuraccparts.OPERATOR_CONTEXT,
vcuraccparts.DRIVER_CONTEXT,
vcuraccparts.FARE_CONTEXT,
vcuraccparts.PCOUNT,
vcuraccparts.PDOLLARS,
/* vcuraccparts.PCASH,*/
FARE_CONTEXT.cashbox_glid,
fare_context.cb_sernum,
probehist.farebox_GLID ,
BUS.BUS_ID ,
GARAGE.GARAGE_ID
from probehist, vcuraccparts,probe_context, fare_context, farebox, bus, garage
where probehist.conversion_num = probe_context.conversion_num and
probe_context.probe_context_id = vcuraccparts.probe_context and
fare_context.fare_context_id(+) = vcuraccparts.fare_context and
PROBEHIST.FAREBOX_GLID = FAREBOX.GLID AND
FAREBOX.LOCATION = BUS.GLID AND
BUS.GARAGEID = GARAGE.GLID;